package cn.gson.crm.model.mapper;

import cn.gson.crm.model.pojos.*;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.springframework.stereotype.Repository;

import java.util.List;

@Mapper
@Repository
public interface CaigouMapper {
    public List<Purchasexq> cxcg(@Param("name")String name,@Param("start")String datas,@Param("end")String dates1);

    //查询采购名称
    public List<Pro> cgmc();

    //查询供货商下拉框
    public List<Supplier> ghs();

    //根据供货商名查询联系人
    public List<Supplier> ghsm(@Param("ghsm")String ghsm);

    //根据供货商联系人查询联系电话
    public List<Supplier> dian(@Param("xi")String xi);

    //添加产品
    public List<SpecifValue> tjcp();

    //根据产品名称查询
    public List<ProductXq> mccx();

    //根据采购id查询采购表
    public List<Purchasexq> cgid(@Param("cgid")Integer cgid);

    //根据产品名称查询产品id
    public List<Pro> chanpinid(@Param("chanpinid")String chanpinid);

    public List<Purchasexq> cgmx1(@Param("caigouid")Integer caigouid);

    public List<User> user();
}
